Dataset statistics
| Number of variables | 52 |
|---|---|
| Number of observations | 11573 |
| Missing cells | 328835 |
| Missing cells (%) | 54.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.6 MiB |
| Average record size in memory | 2.1 KiB |
Variable types
| CAT | 45 |
|---|---|
| NUM | 7 |
Reproduction
| Analysis started | 2020-04-28 23:10:12.943292 |
|---|---|
| Analysis finished | 2020-04-28 23:11:21.227991 |
| Version | pandas-profiling v2.6.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
saledate has a high cardinality: 94 distinct values | High cardinality |
fiModelDesc has a high cardinality: 1731 distinct values | High cardinality |
fiBaseModel has a high cardinality: 786 distinct values | High cardinality |
fiSecondaryDesc has a high cardinality: 81 distinct values | High cardinality |
fiModelSeries has a high cardinality: 59 distinct values | High cardinality |
fiModelDescriptor has a high cardinality: 73 distinct values | High cardinality |
fiProductClassDesc has a high cardinality: 67 distinct values | High cardinality |
ProductGroupDesc is highly correlated with ProductGroup | High Correlation |
ProductGroup is highly correlated with ProductGroupDesc | High Correlation |
MachineHoursCurrentMeter has 6834 (59.1%) missing values | Missing |
UsageBand has 7542 (65.2%) missing values | Missing |
fiSecondaryDesc has 3536 (30.6%) missing values | Missing |
fiModelSeries has 9814 (84.8%) missing values | Missing |
fiModelDescriptor has 8676 (75.0%) missing values | Missing |
ProductSize has 5830 (50.4%) missing values | Missing |
Drive_System has 8847 (76.4%) missing values | Missing |
Forks has 5935 (51.3%) missing values | Missing |
Pad_Type has 9611 (83.0%) missing values | Missing |
Ride_Control has 7451 (64.4%) missing values | Missing |
Stick has 9611 (83.0%) missing values | Missing |
Transmission has 6796 (58.7%) missing values | Missing |
Turbocharged has 9611 (83.0%) missing values | Missing |
Blade_Extension has 10809 (93.4%) missing values | Missing |
Blade_Width has 10809 (93.4%) missing values | Missing |
Enclosure_Type has 10809 (93.4%) missing values | Missing |
Engine_Horsepower has 10809 (93.4%) missing values | Missing |
Hydraulics has 2010 (17.4%) missing values | Missing |
Pushblock has 10809 (93.4%) missing values | Missing |
Ripper has 8765 (75.7%) missing values | Missing |
Scarifier has 10809 (93.4%) missing values | Missing |
Tip_Control has 10809 (93.4%) missing values | Missing |
Tire_Size has 8653 (74.8%) missing values | Missing |
Coupler has 4846 (41.9%) missing values | Missing |
Coupler_System has 10057 (86.9%) missing values | Missing |
Grouser_Tracks has 10060 (86.9%) missing values | Missing |
Hydraulics_Flow has 10060 (86.9%) missing values | Missing |
Track_Type has 8533 (73.7%) missing values | Missing |
Undercarriage_Pad_Width has 8529 (73.7%) missing values | Missing |
Stick_Length has 8530 (73.7%) missing values | Missing |
Thumb has 8529 (73.7%) missing values | Missing |
Pattern_Changer has 8530 (73.7%) missing values | Missing |
Grouser_Type has 8533 (73.7%) missing values | Missing |
Backhoe_Mounting has 9533 (82.4%) missing values | Missing |
Blade_Type has 9531 (82.4%) missing values | Missing |
Travel_Controls has 9530 (82.3%) missing values | Missing |
Differential_Type has 9420 (81.4%) missing values | Missing |
Steering_Controls has 9420 (81.4%) missing values | Missing |
auctioneerID has 129 (1.1%) zeros | Zeros |
MachineHoursCurrentMeter has 708 (6.1%) zeros | Zeros |
| Distinct count | 11573 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5180809.187246176 |
|---|---|
| Minimum | 1222837 |
| Maximum | 6333349 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 1222837 |
|---|---|
| 5-th percentile | 1225118.6 |
| Q1 | 4312616 |
| median | 6264848 |
| Q3 | 6286342 |
| 95-th percentile | 6317178.8 |
| Maximum | 6333349 |
| Range | 5110512 |
| Interquartile range (IQR) | 1973726 |
Descriptive statistics
| Standard deviation | 1619443.493 |
|---|---|
| Coefficient of variation (CV) | 0.3125850489 |
| Kurtosis | 0.9371250427 |
| Mean | 5180809.187 |
| Median Absolute Deviation (MAD) | 1340449.682 |
| Skewness | -1.401197889 |
| Sum | 5.995750472e+10 |
| Variance | 2.622597228e+12 |
| Value | Count | Frequency (%) | |
| 6271032 | 1 | < 0.1% | |
| 4300129 | 1 | < 0.1% | |
| 6274397 | 1 | < 0.1% | |
| 4312411 | 1 | < 0.1% | |
| 6266201 | 1 | < 0.1% | |
| 6303694 | 1 | < 0.1% | |
| 6301014 | 1 | < 0.1% | |
| 6258005 | 1 | < 0.1% | |
| 1226068 | 1 | < 0.1% | |
| 4261202 | 1 | < 0.1% | |
| Other values (11563) | 11563 | 99.9% |
| Value | Count | Frequency (%) | |
| 1222837 | 1 | < 0.1% | |
| 1222839 | 1 | < 0.1% | |
| 1222841 | 1 | < 0.1% | |
| 1222843 | 1 | < 0.1% | |
| 1222845 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6333349 | 1 | < 0.1% | |
| 6333348 | 1 | < 0.1% | |
| 6333347 | 1 | < 0.1% | |
| 6333345 | 1 | < 0.1% | |
| 6333344 | 1 | < 0.1% |
MachineID
Real number (ℝ≥0)
| Distinct count | 9681 |
|---|---|
| Unique (%) | 83.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1651494.6219649184 |
|---|---|
| Minimum | 150 |
| Maximum | 2485252 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 150 |
|---|---|
| 5-th percentile | 214793.4 |
| Q1 | 1067304 |
| median | 1862151 |
| Q3 | 2270530 |
| 95-th percentile | 2304793.8 |
| Maximum | 2485252 |
| Range | 2485102 |
| Interquartile range (IQR) | 1203226 |
Descriptive statistics
| Standard deviation | 652248.5331 |
|---|---|
| Coefficient of variation (CV) | 0.3949443882 |
| Kurtosis | -0.03515233719 |
| Mean | 1651494.622 |
| Median Absolute Deviation (MAD) | 532712.0637 |
| Skewness | -1.037874401 |
| Sum | 1.911274726e+10 |
| Variance | 4.25428149e+11 |
| Value | Count | Frequency (%) | |
| 2283592 | 22 | 0.2% | |
| 2285830 | 19 | 0.2% | |
| 1896854 | 18 | 0.2% | |
| 1746392 | 15 | 0.1% | |
| 2300370 | 14 | 0.1% | |
| 2293171 | 14 | 0.1% | |
| 2268800 | 13 | 0.1% | |
| 2282547 | 13 | 0.1% | |
| 2297316 | 12 | 0.1% | |
| 2313570 | 12 | 0.1% | |
| Other values (9671) | 11421 | 98.7% |
| Value | Count | Frequency (%) | |
| 150 | 1 | < 0.1% | |
| 257 | 1 | < 0.1% | |
| 706 | 1 | < 0.1% | |
| 1012 | 1 | < 0.1% | |
| 1488 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2485252 | 1 | < 0.1% | |
| 2484623 | 1 | < 0.1% | |
| 2484122 | 1 | < 0.1% | |
| 2484120 | 1 | < 0.1% | |
| 2478468 | 1 | < 0.1% |
ModelID
Real number (ℝ≥0)
| Distinct count | 1763 |
|---|---|
| Unique (%) | 15.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8940.13583340534 |
|---|---|
| Minimum | 28 |
| Maximum | 37197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 28 |
|---|---|
| 5-th percentile | 1083.4 |
| Q1 | 3362 |
| median | 4763 |
| Q3 | 14303 |
| 95-th percentile | 23931 |
| Maximum | 37197 |
| Range | 37169 |
| Interquartile range (IQR) | 10941 |
Descriptive statistics
| Standard deviation | 7807.393696 |
|---|---|
| Coefficient of variation (CV) | 0.873296988 |
| Kurtosis | 0.2842979286 |
| Mean | 8940.135833 |
| Median Absolute Deviation (MAD) | 6559.855447 |
| Skewness | 1.055996828 |
| Sum | 103464192 |
| Variance | 60955396.32 |
| Value | Count | Frequency (%) | |
| 4605 | 309 | 2.7% | |
| 3542 | 116 | 1.0% | |
| 3538 | 107 | 0.9% | |
| 3362 | 103 | 0.9% | |
| 13247 | 91 | 0.8% | |
| 23931 | 79 | 0.7% | |
| 1169 | 73 | 0.6% | |
| 9580 | 71 | 0.6% | |
| 22072 | 65 | 0.6% | |
| 4607 | 65 | 0.6% | |
| Other values (1753) | 10494 | 90.7% |
| Value | Count | Frequency (%) | |
| 28 | 6 | 0.1% | |
| 29 | 8 | 0.1% | |
| 31 | 4 | < 0.1% | |
| 34 | 3 | < 0.1% | |
| 43 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 37197 | 2 | < 0.1% | |
| 36932 | 1 | < 0.1% | |
| 36894 | 1 | < 0.1% | |
| 36879 | 1 | < 0.1% | |
| 36779 | 2 | < 0.1% |
datasource
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152.62265618249373 |
|---|---|
| Minimum | 121 |
| Maximum | 173 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 121 |
|---|---|
| 5-th percentile | 121 |
| Q1 | 149 |
| median | 149 |
| Q3 | 172 |
| 95-th percentile | 172 |
| Maximum | 173 |
| Range | 52 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 14.87206399 |
|---|---|
| Coefficient of variation (CV) | 0.09744335709 |
| Kurtosis | -0.02259949746 |
| Mean | 152.6226562 |
| Median Absolute Deviation (MAD) | 11.10451432 |
| Skewness | -0.3873764293 |
| Sum | 1766302 |
| Variance | 221.1782872 |
| Value | Count | Frequency (%) | |
| 149 | 7021 | 60.7% | |
| 172 | 3315 | 28.6% | |
| 121 | 1212 | 10.5% | |
| 132 | 24 | 0.2% | |
| 173 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 121 | 1212 | 10.5% | |
| 132 | 24 | 0.2% | |
| 149 | 7021 | 60.7% | |
| 172 | 3315 | 28.6% | |
| 173 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 173 | 1 | < 0.1% | |
| 172 | 3315 | 28.6% | |
| 149 | 7021 | 60.7% | |
| 132 | 24 | 0.2% | |
| 121 | 1212 | 10.5% |
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.547481206255941 |
|---|---|
| Minimum | 0 |
| Maximum | 99 |
| Zeros | 129 |
| Zeros (%) | 1.1% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 99 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 22.30707735 |
|---|---|
| Coefficient of variation (CV) | 2.955565803 |
| Kurtosis | 12.54377359 |
| Mean | 7.547481206 |
| Median Absolute Deviation (MAD) | 10.77200996 |
| Skewness | 3.774991416 |
| Sum | 87347 |
| Variance | 497.6056999 |
| Value | Count | Frequency (%) | |
| 1 | 7463 | 64.5% | |
| 3 | 1212 | 10.5% | |
| 2 | 1001 | 8.6% | |
| 99 | 636 | 5.5% | |
| 4 | 403 | 3.5% | |
| 8 | 216 | 1.9% | |
| 12 | 192 | 1.7% | |
| 0 | 129 | 1.1% | |
| 26 | 120 | 1.0% | |
| 10 | 86 | 0.7% | |
| Other values (4) | 115 | 1.0% |
| Value | Count | Frequency (%) | |
| 0 | 129 | 1.1% | |
| 1 | 7463 | 64.5% | |
| 2 | 1001 | 8.6% | |
| 3 | 1212 | 10.5% | |
| 4 | 403 | 3.5% |
| Value | Count | Frequency (%) | |
| 99 | 636 | 5.5% | |
| 26 | 120 | 1.0% | |
| 16 | 15 | 0.1% | |
| 15 | 62 | 0.5% | |
| 13 | 37 | 0.3% |
YearMade
Real number (ℝ≥0)
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1895.3318067916703 |
|---|---|
| Minimum | 1000 |
| Maximum | 2014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1993 |
| median | 2001 |
| Q3 | 2005 |
| 95-th percentile | 2007 |
| Maximum | 2014 |
| Range | 1014 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 305.4819013 |
|---|---|
| Coefficient of variation (CV) | 0.1611759483 |
| Kurtosis | 4.705841297 |
| Mean | 1895.331807 |
| Median Absolute Deviation (MAD) | 186.6016001 |
| Skewness | -2.588151402 |
| Sum | 21934675 |
| Variance | 93319.192 |
| Value | Count | Frequency (%) | |
| 2005 | 1509 | 13.0% | |
| 2006 | 1211 | 10.5% | |
| 1000 | 1206 | 10.4% | |
| 2004 | 894 | 7.7% | |
| 1998 | 530 | 4.6% | |
| 2007 | 525 | 4.5% | |
| 1999 | 507 | 4.4% | |
| 2003 | 500 | 4.3% | |
| 2000 | 496 | 4.3% | |
| 2001 | 447 | 3.9% | |
| Other values (45) | 3748 | 32.4% |
| Value | Count | Frequency (%) | |
| 1000 | 1206 | 10.4% | |
| 1953 | 1 | < 0.1% | |
| 1957 | 1 | < 0.1% | |
| 1958 | 3 | < 0.1% | |
| 1962 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2014 | 2 | < 0.1% | |
| 2011 | 13 | 0.1% | |
| 2010 | 33 | 0.3% | |
| 2009 | 44 | 0.4% | |
| 2008 | 269 | 2.3% |
| Distinct count | 3075 |
|---|---|
| Unique (%) | 64.9% |
| Missing | 6834 |
| Missing (%) | 59.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5482.141380037982 |
|---|---|
| Minimum | 0.0 |
| Maximum | 89200.0 |
| Zeros | 708 |
| Zeros (%) | 6.1% |
| Memory size | 90.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1268 |
| median | 3786 |
| Q3 | 7793 |
| 95-th percentile | 16351.7 |
| Maximum | 89200 |
| Range | 89200 |
| Interquartile range (IQR) | 6525 |
Descriptive statistics
| Standard deviation | 6391.097182 |
|---|---|
| Coefficient of variation (CV) | 1.165803057 |
| Kurtosis | 23.65812955 |
| Mean | 5482.14138 |
| Median Absolute Deviation (MAD) | 4356.48669 |
| Skewness | 3.373997252 |
| Sum | 25979868 |
| Variance | 40846123.19 |
| Value | Count | Frequency (%) | |
| 0 | 708 | 6.1% | |
| 24 | 74 | 0.6% | |
| 48 | 43 | 0.4% | |
| 1553 | 5 | < 0.1% | |
| 1916 | 5 | < 0.1% | |
| 3311 | 4 | < 0.1% | |
| 9070 | 4 | < 0.1% | |
| 9192 | 4 | < 0.1% | |
| 828 | 4 | < 0.1% | |
| 7798 | 4 | < 0.1% | |
| Other values (3065) | 3884 | 33.6% | |
| (Missing) | 6834 | 59.1% |
| Value | Count | Frequency (%) | |
| 0 | 708 | 6.1% | |
| 1 | 2 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 89200 | 2 | < 0.1% | |
| 73860 | 1 | < 0.1% | |
| 59431 | 1 | < 0.1% | |
| 55214 | 1 | < 0.1% | |
| 53839 | 1 | < 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7542 |
| Missing (%) | 65.2% |
| Memory size | 90.5 KiB |
| Medium | |
|---|---|
| Low | |
| High |
| Value | Count | Frequency (%) | |
| Medium | 1847 | 16.0% | |
| Low | 1691 | 14.6% | |
| High | 493 | 4.3% | |
| (Missing) | 7542 | 65.2% |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.521385985 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 78.6% | |
| Uppercase_Letter | 3 | 21.4% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
| Distinct count | 94 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| 2/13/2012 0:00 | |
|---|---|
| 3/29/2012 0:00 | 765 |
| 2/12/2012 0:00 | 698 |
| 3/28/2012 0:00 | 584 |
| 1/28/2012 0:00 | 510 |
| Other values (89) |
| Value | Count | Frequency (%) | |
| 2/13/2012 0:00 | 1598 | 13.8% | |
| 3/29/2012 0:00 | 765 | 6.6% | |
| 2/12/2012 0:00 | 698 | 6.0% | |
| 3/28/2012 0:00 | 584 | 5.0% | |
| 1/28/2012 0:00 | 510 | 4.4% | |
| 3/22/2012 0:00 | 384 | 3.3% | |
| 2/6/2012 0:00 | 381 | 3.3% | |
| 3/8/2012 0:00 | 353 | 3.1% | |
| 3/26/2012 0:00 | 321 | 2.8% | |
| 3/14/2012 0:00 | 288 | 2.5% | |
| Other values (84) | 5691 | 49.2% |
Length
| Max length | 14 |
|---|---|
| Mean length | 13.8146548 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 76.9% | |
| Other_Punctuation | 2 | 15.4% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 1731 |
|---|---|
| Unique (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| 310G | 309 |
|---|---|
| 420D | 116 |
| 416C | 107 |
| 140G | 103 |
| 580MII | 91 |
| Other values (1726) |
| Value | Count | Frequency (%) | |
| 310G | 309 | 2.7% | |
| 420D | 116 | 1.0% | |
| 416C | 107 | 0.9% | |
| 140G | 103 | 0.9% | |
| 580MII | 91 | 0.8% | |
| 140HNA | 79 | 0.7% | |
| 320CL | 73 | 0.6% | |
| T190 | 71 | 0.6% | |
| 310SG | 65 | 0.6% | |
| D6NLGP | 65 | 0.6% | |
| Other values (1721) | 10494 | 90.7% |
Length
| Max length | 16 |
|---|---|
| Mean length | 4.990149486 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 66.7% | |
| Decimal_Number | 10 | 25.6% | |
| Other_Punctuation | 1 | 2.6% | |
| Space_Separator | 1 | 2.6% | |
| Dash_Punctuation | 1 | 2.6% |
| Value | Count | Frequency (%) | |
| Latin | 26 | 66.7% | |
| Common | 13 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 39 | 100.0% |
| Distinct count | 786 |
|---|---|
| Unique (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| 310 | 532 |
|---|---|
| D6 | 417 |
| 580 | 381 |
| D5 | 294 |
| 416 | 213 |
| Other values (781) |
| Value | Count | Frequency (%) | |
| 310 | 532 | 4.6% | |
| D6 | 417 | 3.6% | |
| 580 | 381 | 3.3% | |
| D5 | 294 | 2.5% | |
| 416 | 213 | 1.8% | |
| 950 | 199 | 1.7% | |
| 140 | 185 | 1.6% | |
| 650 | 170 | 1.5% | |
| D8 | 170 | 1.5% | |
| 12 | 158 | 1.4% | |
| Other values (776) | 8854 | 76.5% |
Length
| Max length | 10 |
|---|---|
| Mean length | 3.299403785 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 66.7% | |
| Decimal_Number | 10 | 27.8% | |
| Other_Punctuation | 1 | 2.8% | |
| Space_Separator | 1 | 2.8% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 66.7% | |
| Common | 12 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 36 | 100.0% |
| Distinct count | 81 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 3536 |
| Missing (%) | 30.6% |
| Memory size | 90.5 KiB |
| G | |
|---|---|
| C | |
| B | |
| H | |
| D | 566 |
| Other values (76) |
| Value | Count | Frequency (%) | |
| G | 1491 | 12.9% | |
| C | 1196 | 10.3% | |
| B | 962 | 8.3% | |
| H | 679 | 5.9% | |
| D | 566 | 4.9% | |
| E | 484 | 4.2% | |
| J | 278 | 2.4% | |
| F | 267 | 2.3% | |
| M | 226 | 2.0% | |
| N | 209 | 1.8% | |
| Other values (71) | 1679 | 14.5% | |
| (Missing) | 3536 | 30.6% |
Length
| Max length | 7 |
|---|---|
| Mean length | 1.776030416 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 22 | 75.9% | |
| Decimal_Number | 2 | 6.9% | |
| Other_Punctuation | 2 | 6.9% | |
| Lowercase_Letter | 2 | 6.9% | |
| Space_Separator | 1 | 3.4% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 82.8% | |
| Common | 5 | 17.2% |
| Value | Count | Frequency (%) | |
| ASCII | 29 | 100.0% |
| Distinct count | 59 |
|---|---|
| Unique (%) | 3.4% |
| Missing | 9814 |
| Missing (%) | 84.8% |
| Memory size | 90.5 KiB |
| II | |
|---|---|
| LC | |
| III | 113 |
| -2 | 81 |
| -5 | 70 |
| Other values (54) |
| Value | Count | Frequency (%) | |
| II | 568 | 4.9% | |
| LC | 239 | 2.1% | |
| III | 113 | 1.0% | |
| -2 | 81 | 0.7% | |
| -5 | 70 | 0.6% | |
| -6 | 68 | 0.6% | |
| -1 | 55 | 0.5% | |
| IV | 48 | 0.4% | |
| V | 40 | 0.3% | |
| -3 | 40 | 0.3% | |
| Other values (49) | 437 | 3.8% | |
| (Missing) | 9814 | 84.8% |
Length
| Max length | 8 |
|---|---|
| Mean length | 2.864771451 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 16 | 50.0% | |
| Decimal_Number | 9 | 28.1% | |
| Other_Punctuation | 3 | 9.4% | |
| Lowercase_Letter | 2 | 6.2% | |
| Math_Symbol | 1 | 3.1% | |
| Dash_Punctuation | 1 | 3.1% |
| Value | Count | Frequency (%) | |
| Latin | 18 | 56.2% | |
| Common | 14 | 43.8% |
| Value | Count | Frequency (%) | |
| ASCII | 32 | 100.0% |
| Distinct count | 73 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 8676 |
| Missing (%) | 75.0% |
| Memory size | 90.5 KiB |
| L | |
|---|---|
| LGP | |
| LC | |
| XL | |
| CR | 114 |
| Other values (68) |
| Value | Count | Frequency (%) | |
| L | 589 | 5.1% | |
| LGP | 585 | 5.1% | |
| LC | 545 | 4.7% | |
| XL | 266 | 2.3% | |
| CR | 114 | 1.0% | |
| LT | 111 | 1.0% | |
| 6 | 59 | 0.5% | |
| 5 | 55 | 0.5% | |
| 7 | 45 | 0.4% | |
| E | 43 | 0.4% | |
| Other values (63) | 485 | 4.2% | |
| (Missing) | 8676 | 75.0% |
Length
| Max length | 8 |
|---|---|
| Mean length | 2.738442928 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 63.2% | |
| Decimal_Number | 9 | 23.7% | |
| Lowercase_Letter | 2 | 5.3% | |
| Space_Separator | 1 | 2.6% | |
| Other_Punctuation | 1 | 2.6% | |
| Math_Symbol | 1 | 2.6% |
| Value | Count | Frequency (%) | |
| Latin | 26 | 68.4% | |
| Common | 12 | 31.6% |
| Value | Count | Frequency (%) | |
| ASCII | 38 | 100.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 5830 |
| Missing (%) | 50.4% |
| Memory size | 90.5 KiB |
| Medium | |
|---|---|
| Large / Medium | |
| Mini | |
| Small | |
| Large |
| Value | Count | Frequency (%) | |
| Medium | 2068 | 17.9% | |
| Large / Medium | 1619 | 14.0% | |
| Mini | 881 | 7.6% | |
| Small | 563 | 4.9% | |
| Large | 421 | 3.6% | |
| Compact | 191 | 1.7% | |
| (Missing) | 5830 | 50.4% |
Length
| Max length | 14 |
|---|---|
| Mean length | 5.387107924 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 14 | 70.0% | |
| Uppercase_Letter | 4 | 20.0% | |
| Other_Punctuation | 1 | 5.0% | |
| Space_Separator | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| Latin | 18 | 90.0% | |
| Common | 2 | 10.0% |
| Value | Count | Frequency (%) | |
| ASCII | 20 | 100.0% |
| Distinct count | 67 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| Backhoe Loader - 14.0 to 15.0 Ft Standard Digging Depth | 1376 |
|---|---|
| Track Type Tractor, Dozer - 85.0 to 105.0 Horsepower | 430 |
| Wheel Loader - 150.0 to 175.0 Horsepower | 423 |
| Hydraulic Excavator, Track - 21.0 to 24.0 Metric Tons | 413 |
| Track Type Tractor, Dozer - 130.0 to 160.0 Horsepower | 390 |
| Other values (62) |
| Value | Count | Frequency (%) | |
| Backhoe Loader - 14.0 to 15.0 Ft Standard Digging Depth | 1376 | 11.9% | |
| Track Type Tractor, Dozer - 85.0 to 105.0 Horsepower | 430 | 3.7% | |
| Wheel Loader - 150.0 to 175.0 Horsepower | 423 | 3.7% | |
| Hydraulic Excavator, Track - 21.0 to 24.0 Metric Tons | 413 | 3.6% | |
| Track Type Tractor, Dozer - 130.0 to 160.0 Horsepower | 390 | 3.4% | |
| Wheel Loader - 120.0 to 135.0 Horsepower | 361 | 3.1% | |
| Skid Steer Loader - 1751.0 to 2201.0 Lb Operating Capacity | 357 | 3.1% | |
| Track Type Tractor, Dozer - 20.0 to 75.0 Horsepower | 343 | 3.0% | |
| Hydraulic Excavator, Track - 33.0 to 40.0 Metric Tons | 307 | 2.7% | |
| Hydraulic Excavator, Track - 3.0 to 4.0 Metric Tons | 304 | 2.6% | |
| Other values (57) | 6869 | 59.4% |
Length
| Max length | 58 |
|---|---|
| Mean length | 49.67182235 |
| Min length | 27 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 23 | 45.1% | |
| Uppercase_Letter | 13 | 25.5% | |
| Decimal_Number | 10 | 19.6% | |
| Other_Punctuation | 2 | 3.9% | |
| Math_Symbol | 1 | 2.0% | |
| Space_Separator | 1 | 2.0% | |
| Dash_Punctuation | 1 | 2.0% |
| Value | Count | Frequency (%) | |
| Latin | 36 | 70.6% | |
| Common | 15 | 29.4% |
| Value | Count | Frequency (%) | |
| ASCII | 51 | 100.0% |
state
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| Florida | |
|---|---|
| Texas | |
| California | 742 |
| Maryland | 357 |
| Illinois | 331 |
| Other values (43) |
| Value | Count | Frequency (%) | |
| Florida | 3376 | 29.2% | |
| Texas | 1428 | 12.3% | |
| California | 742 | 6.4% | |
| Maryland | 357 | 3.1% | |
| Illinois | 331 | 2.9% | |
| Georgia | 324 | 2.8% | |
| Alabama | 295 | 2.5% | |
| Pennsylvania | 293 | 2.5% | |
| Mississippi | 279 | 2.4% | |
| Colorado | 275 | 2.4% | |
| Other values (38) | 3873 | 33.5% |
Length
| Max length | 14 |
|---|---|
| Mean length | 7.845588871 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 24 | 52.2% | |
| Uppercase_Letter | 21 | 45.7% | |
| Space_Separator | 1 | 2.2% |
| Value | Count | Frequency (%) | |
| Latin | 45 | 97.8% | |
| Common | 1 | 2.2% |
| Value | Count | Frequency (%) | |
| ASCII | 46 | 100.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| TEX | |
|---|---|
| WL | |
| TTT | |
| BL | |
| SSL |
| Value | Count | Frequency (%) | |
| TEX | 3063 | 26.5% | |
| WL | 2170 | 18.8% | |
| TTT | 2062 | 17.8% | |
| BL | 1986 | 17.2% | |
| SSL | 1523 | 13.2% | |
| MG | 769 | 6.6% |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.574440508 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 90.5 KiB |
| Track Excavators | |
|---|---|
| Wheel Loader | |
| Track Type Tractors | |
| Backhoe Loaders | |
| Skid Steer Loaders |
| Value | Count | Frequency (%) | |
| Track Excavators | 3063 | 26.5% | |
| Wheel Loader | 2170 | 18.8% | |
| Track Type Tractors | 2062 | 17.8% | |
| Backhoe Loaders | 1986 | 17.2% | |
| Skid Steer Loaders | 1523 | 13.2% | |
| Motor Graders | 769 | 6.6% |
Length
| Max length | 19 |
|---|---|
| Mean length | 15.6767476 |
| Min length | 12 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 16 | 64.0% | |
| Uppercase_Letter | 8 | 32.0% | |
| Space_Separator | 1 | 4.0% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 96.0% | |
| Common | 1 | 4.0% |
| Value | Count | Frequency (%) | |
| ASCII | 25 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8847 |
| Missing (%) | 76.4% |
| Memory size | 90.5 KiB |
| Two Wheel Drive | |
|---|---|
| No | |
| Four Wheel Drive | |
| All Wheel Drive | 26 |
| Value | Count | Frequency (%) | |
| Two Wheel Drive | 1407 | 12.2% | |
| No | 738 | 6.4% | |
| Four Wheel Drive | 555 | 4.8% | |
| All Wheel Drive | 26 | 0.2% | |
| (Missing) | 8847 | 76.4% |
Length
| Max length | 16 |
|---|---|
| Mean length | 5.045537026 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 61.1% | |
| Uppercase_Letter | 6 | 33.3% | |
| Space_Separator | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Latin | 17 | 94.4% | |
| Common | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Enclosure
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9 |
| Missing (%) | 0.1% |
| Memory size | 90.5 KiB |
| EROPS w AC | |
|---|---|
| OROPS | |
| EROPS | |
| EROPS AC | 1 |
| Value | Count | Frequency (%) | |
| EROPS w AC | 4781 | 41.3% | |
| OROPS | 4039 | 34.9% | |
| EROPS | 2743 | 23.7% | |
| EROPS AC | 1 | < 0.1% | |
| (Missing) | 9 | 0.1% |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.064287566 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 7 | 63.6% | |
| Lowercase_Letter | 3 | 27.3% | |
| Space_Separator | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Latin | 10 | 90.9% | |
| Common | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 5935 |
| Missing (%) | 51.3% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 877 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 4761 | 41.1% | |
| Yes | 877 | 7.6% | |
| (Missing) | 5935 | 51.3% |
Length
| Max length | 19 |
|---|---|
| Mean length | 9.58221723 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 9611 |
| Missing (%) | 83.0% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Reversible | 118 |
| Street | 62 |
| Grouser | 1 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1781 | 15.4% | |
| Reversible | 118 | 1.0% | |
| Street | 62 | 0.5% | |
| Grouser | 1 | < 0.1% | |
| (Missing) | 9611 | 83.0% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.550073447 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 16 | 72.7% | |
| Uppercase_Letter | 5 | 22.7% | |
| Space_Separator | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| Latin | 21 | 95.5% | |
| Common | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| ASCII | 22 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7451 |
| Missing (%) | 64.4% |
| Memory size | 90.5 KiB |
| No | |
|---|---|
| None or Unspecified | |
| Yes |
| Value | Count | Frequency (%) | |
| No | 1704 | 14.7% | |
| None or Unspecified | 1577 | 13.6% | |
| Yes | 841 | 7.3% | |
| (Missing) | 7451 | 64.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.033007863 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 9611 |
| Missing (%) | 83.0% |
| Memory size | 90.5 KiB |
| Standard | |
|---|---|
| Extended |
| Value | Count | Frequency (%) | |
| Standard | 1025 | 8.9% | |
| Extended | 937 | 8.1% | |
| (Missing) | 9611 | 83.0% |
Length
| Max length | 8 |
|---|---|
| Mean length | 3.847662663 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 7 | 77.8% | |
| Uppercase_Letter | 2 | 22.2% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 6796 |
| Missing (%) | 58.7% |
| Memory size | 90.5 KiB |
| Standard | |
|---|---|
| None or Unspecified | |
| Powershift | 260 |
| Hydrostatic | 138 |
| Powershuttle | 42 |
| Other values (2) | 8 |
| Value | Count | Frequency (%) | |
| Standard | 3587 | 31.0% | |
| None or Unspecified | 742 | 6.4% | |
| Powershift | 260 | 2.2% | |
| Hydrostatic | 138 | 1.2% | |
| Powershuttle | 42 | 0.4% | |
| Autoshift | 4 | < 0.1% | |
| Direct Drive | 4 | < 0.1% | |
| (Missing) | 6796 | 58.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.866067571 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 18 | 69.2% | |
| Uppercase_Letter | 7 | 26.9% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Latin | 25 | 96.2% | |
| Common | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 9611 |
| Missing (%) | 83.0% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 62 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1900 | 16.4% | |
| Yes | 62 | 0.5% | |
| (Missing) | 9611 | 83.0% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.626803767 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 50 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 714 | 6.2% | |
| Yes | 50 | 0.4% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.987125205 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| 14' | |
|---|---|
| None or Unspecified | |
| 12' | |
| 16' | 27 |
| <12' | 8 |
| Value | Count | Frequency (%) | |
| 14' | 252 | 2.2% | |
| None or Unspecified | 238 | 2.1% | |
| 12' | 233 | 2.0% | |
| 16' | 27 | 0.2% | |
| <12' | 8 | 0.1% | |
| 13' | 6 | 0.1% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.329732999 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 52.4% | |
| Decimal_Number | 5 | 23.8% | |
| Uppercase_Letter | 2 | 9.5% | |
| Other_Punctuation | 1 | 4.8% | |
| Space_Separator | 1 | 4.8% | |
| Math_Symbol | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 13 | 61.9% | |
| Common | 8 | 38.1% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Low Profile | |
| High Profile | 53 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 546 | 4.7% | |
| Low Profile | 165 | 1.4% | |
| High Profile | 53 | 0.5% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.910135661 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 15 | 71.4% | |
| Uppercase_Letter | 5 | 23.8% | |
| Space_Separator | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| No | |
|---|---|
| Variable | 59 |
| Value | Count | Frequency (%) | |
| No | 705 | 6.1% | |
| Variable | 59 | 0.5% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 8 |
|---|---|
| Mean length | 2.964572712 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 8 | 80.0% | |
| Uppercase_Letter | 2 | 20.0% |
| Value | Count | Frequency (%) | |
| Latin | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 10 | 100.0% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 2010 |
| Missing (%) | 17.4% |
| Memory size | 90.5 KiB |
| 2 Valve | |
|---|---|
| Auxiliary | |
| Standard | |
| Base + 1 Function | 741 |
| 3 Valve | 185 |
| Other values (6) | 145 |
| Value | Count | Frequency (%) | |
| 2 Valve | 3913 | 33.8% | |
| Auxiliary | 2487 | 21.5% | |
| Standard | 2092 | 18.1% | |
| Base + 1 Function | 741 | 6.4% | |
| 3 Valve | 185 | 1.6% | |
| 4 Valve | 117 | 1.0% | |
| Base + 3 Function | 12 | 0.1% | |
| Base + 4 Function | 5 | < 0.1% | |
| Base + 2 Function | 5 | < 0.1% | |
| Base + 5 Function | 5 | < 0.1% | |
| (Missing) | 2010 | 17.4% |
Length
| Max length | 17 |
|---|---|
| Mean length | 7.580316253 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 15 | 53.6% | |
| Decimal_Number | 6 | 21.4% | |
| Uppercase_Letter | 5 | 17.9% | |
| Space_Separator | 1 | 3.6% | |
| Math_Symbol | 1 | 3.6% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 71.4% | |
| Common | 8 | 28.6% |
| Value | Count | Frequency (%) | |
| ASCII | 28 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| None or Unspecified | 554 | 4.8% | |
| Yes | 210 | 1.8% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.765920677 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8765 |
| Missing (%) | 75.7% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Multi Shank | |
| Yes | 283 |
| Single Shank | 134 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1953 | 16.9% | |
| Multi Shank | 438 | 3.8% | |
| Yes | 283 | 2.4% | |
| Single Shank | 134 | 1.2% | |
| (Missing) | 8765 | 75.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 6.107059535 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 73.9% | |
| Uppercase_Letter | 5 | 21.7% | |
| Space_Separator | 1 | 4.3% |
| Value | Count | Frequency (%) | |
| Latin | 22 | 95.7% | |
| Common | 1 | 4.3% |
| Value | Count | Frequency (%) | |
| ASCII | 23 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| Yes | |
|---|---|
| None or Unspecified |
| Value | Count | Frequency (%) | |
| Yes | 450 | 3.9% | |
| None or Unspecified | 314 | 2.7% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.434113886 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 10809 |
| Missing (%) | 93.4% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Sideshift & Tip | 94 |
| Tip | 45 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 625 | 5.4% | |
| Sideshift & Tip | 94 | 0.8% | |
| Tip | 45 | 0.4% | |
| (Missing) | 10809 | 93.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.961548432 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 68.4% | |
| Uppercase_Letter | 4 | 21.1% | |
| Other_Punctuation | 1 | 5.3% | |
| Space_Separator | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| Latin | 17 | 89.5% | |
| Common | 2 | 10.5% |
| Value | Count | Frequency (%) | |
| ASCII | 19 | 100.0% |
| Distinct count | 15 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 8653 |
| Missing (%) | 74.8% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| 20.5 | |
| 14" | |
| 23.5 | 280 |
| 26.5 | 153 |
| Other values (10) | 174 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1484 | 12.8% | |
| 20.5 | 531 | 4.6% | |
| 14" | 298 | 2.6% | |
| 23.5 | 280 | 2.4% | |
| 26.5 | 153 | 1.3% | |
| 29.5 | 63 | 0.5% | |
| 17.5 | 39 | 0.3% | |
| 17.5" | 22 | 0.2% | |
| 20.5" | 19 | 0.2% | |
| 13" | 10 | 0.1% | |
| Other values (5) | 21 | 0.2% | |
| (Missing) | 8653 | 74.8% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.153719865 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 44.0% | |
| Decimal_Number | 9 | 36.0% | |
| Uppercase_Letter | 2 | 8.0% | |
| Other_Punctuation | 2 | 8.0% | |
| Space_Separator | 1 | 4.0% |
| Value | Count | Frequency (%) | |
| Latin | 13 | 52.0% | |
| Common | 12 | 48.0% |
| Value | Count | Frequency (%) | |
| ASCII | 25 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 4846 |
| Missing (%) | 41.9% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Manual | 617 |
| Hydraulic | 243 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 5867 | 50.7% | |
| Manual | 617 | 5.3% | |
| Hydraulic | 243 | 2.1% | |
| (Missing) | 4846 | 41.9% |
Length
| Max length | 19 |
|---|---|
| Mean length | 11.39721766 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 14 | 73.7% | |
| Uppercase_Letter | 4 | 21.1% | |
| Space_Separator | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| Latin | 18 | 94.7% | |
| Common | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| ASCII | 19 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 10057 |
| Missing (%) | 86.9% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 219 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1297 | 11.2% | |
| Yes | 219 | 1.9% | |
| (Missing) | 10057 | 86.9% |
Length
| Max length | 19 |
|---|---|
| Mean length | 4.793139203 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 10060 |
| Missing (%) | 86.9% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 208 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1305 | 11.3% | |
| Yes | 208 | 1.8% | |
| (Missing) | 10060 | 86.9% |
Length
| Max length | 19 |
|---|---|
| Mean length | 4.80419943 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 10060 |
| Missing (%) | 86.9% |
| Memory size | 90.5 KiB |
| Standard | |
|---|---|
| High Flow | 44 |
| None or Unspecified | 2 |
| Value | Count | Frequency (%) | |
| Standard | 1467 | 12.7% | |
| High Flow | 44 | 0.4% | |
| None or Unspecified | 2 | < 0.1% | |
| (Missing) | 10060 | 86.9% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.65937959 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 16 | 72.7% | |
| Uppercase_Letter | 5 | 22.7% | |
| Space_Separator | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| Latin | 21 | 95.5% | |
| Common | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| ASCII | 22 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8533 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| Steel | |
|---|---|
| Rubber | 457 |
| Value | Count | Frequency (%) | |
| Steel | 2583 | 22.3% | |
| Rubber | 457 | 3.9% | |
| (Missing) | 8533 | 73.7% |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.564849218 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 8 | 80.0% | |
| Uppercase_Letter | 2 | 20.0% |
| Value | Count | Frequency (%) | |
| Latin | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 10 | 100.0% |
| Distinct count | 16 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 8529 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| 32 inch | 74 |
| 28 inch | 38 |
| 24 inch | 36 |
| 36 inch | 25 |
| Other values (11) | 78 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 2793 | 24.1% | |
| 32 inch | 74 | 0.6% | |
| 28 inch | 38 | 0.3% | |
| 24 inch | 36 | 0.3% | |
| 36 inch | 25 | 0.2% | |
| 16 inch | 21 | 0.2% | |
| 20 inch | 12 | 0.1% | |
| 30 inch | 10 | 0.1% | |
| 18 inch | 10 | 0.1% | |
| 34 inch | 9 | 0.1% | |
| Other values (6) | 16 | 0.1% | |
| (Missing) | 8529 | 73.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 6.948155189 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 12 | 52.2% | |
| Decimal_Number | 8 | 34.8% | |
| Uppercase_Letter | 2 | 8.7% | |
| Space_Separator | 1 | 4.3% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 60.9% | |
| Common | 9 | 39.1% |
| Value | Count | Frequency (%) | |
| ASCII | 23 | 100.0% |
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 8530 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| 9' 6" | 67 |
| 10' 6" | 63 |
| 9' 8" | 28 |
| 11' 0" | 24 |
| Other values (16) | 142 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 2719 | 23.5% | |
| 9' 6" | 67 | 0.6% | |
| 10' 6" | 63 | 0.5% | |
| 9' 8" | 28 | 0.2% | |
| 11' 0" | 24 | 0.2% | |
| 9' 10" | 24 | 0.2% | |
| 9' 7" | 22 | 0.2% | |
| 10' 2" | 21 | 0.2% | |
| 12' 10" | 21 | 0.2% | |
| 10' 10" | 10 | 0.1% | |
| Other values (11) | 44 | 0.4% | |
| (Missing) | 8530 | 73.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 6.834787868 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 42.3% | |
| Decimal_Number | 10 | 38.5% | |
| Uppercase_Letter | 2 | 7.7% | |
| Other_Punctuation | 2 | 7.7% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Common | 13 | 50.0% | |
| Latin | 13 | 50.0% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8529 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Hydraulic | |
| Manual | 320 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1981 | 17.1% | |
| Hydraulic | 743 | 6.4% | |
| Manual | 320 | 2.8% | |
| (Missing) | 8529 | 73.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 6.206947205 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 14 | 73.7% | |
| Uppercase_Letter | 4 | 21.1% | |
| Space_Separator | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| Latin | 18 | 94.7% | |
| Common | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| ASCII | 19 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8530 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Yes | 371 |
| No | 3 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 2669 | 23.1% | |
| Yes | 371 | 3.2% | |
| No | 3 | < 0.1% | |
| (Missing) | 8530 | 73.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 6.689708805 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8533 |
| Missing (%) | 73.7% |
| Memory size | 90.5 KiB |
| Double | |
|---|---|
| Triple |
| Value | Count | Frequency (%) | |
| Double | 2345 | 20.3% | |
| Triple | 695 | 6.0% | |
| (Missing) | 8533 | 73.7% |
Length
| Max length | 6 |
|---|---|
| Mean length | 3.78804113 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 10 | 83.3% | |
| Uppercase_Letter | 2 | 16.7% |
| Value | Count | Frequency (%) | |
| Latin | 12 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 12 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9533 |
| Missing (%) | 82.4% |
| Memory size | 90.5 KiB |
| None or Unspecified |
|---|
| Value | Count | Frequency (%) | |
| None or Unspecified | 2040 | 17.6% | |
| (Missing) | 9533 | 82.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.820357729 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 78.6% | |
| Uppercase_Letter | 2 | 14.3% | |
| Space_Separator | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| Latin | 13 | 92.9% | |
| Common | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 9531 |
| Missing (%) | 82.4% |
| Memory size | 90.5 KiB |
| PAT | |
|---|---|
| None or Unspecified | |
| Semi U | |
| Straight | 138 |
| VPAT | 134 |
| Other values (3) | 49 |
| Value | Count | Frequency (%) | |
| PAT | 1021 | 8.8% | |
| None or Unspecified | 410 | 3.5% | |
| Semi U | 290 | 2.5% | |
| Straight | 138 | 1.2% | |
| VPAT | 134 | 1.2% | |
| U | 26 | 0.2% | |
| Angle | 22 | 0.2% | |
| Landfill | 1 | < 0.1% | |
| (Missing) | 9531 | 82.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 3.712952562 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 16 | 64.0% | |
| Uppercase_Letter | 8 | 32.0% | |
| Space_Separator | 1 | 4.0% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 96.0% | |
| Common | 1 | 4.0% |
| Value | Count | Frequency (%) | |
| ASCII | 25 | 100.0% |
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 9530 |
| Missing (%) | 82.3% |
| Memory size | 90.5 KiB |
| None or Unspecified | |
|---|---|
| Differential Steer | |
| Finger Tip | 69 |
| Lever | 62 |
| Pedal | 7 |
| Other values (2) | 3 |
| Value | Count | Frequency (%) | |
| None or Unspecified | 1524 | 13.2% | |
| Differential Steer | 378 | 3.3% | |
| Finger Tip | 69 | 0.6% | |
| Lever | 62 | 0.5% | |
| Pedal | 7 | 0.1% | |
| 2 Pedal | 2 | < 0.1% | |
| 1 Speed | 1 | < 0.1% | |
| (Missing) | 9530 | 82.3% |
Length
| Max length | 19 |
|---|---|
| Mean length | 5.651602869 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 15 | 57.7% | |
| Uppercase_Letter | 8 | 30.8% | |
| Decimal_Number | 2 | 7.7% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Latin | 23 | 88.5% | |
| Common | 3 | 11.5% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 9420 |
| Missing (%) | 81.4% |
| Memory size | 90.5 KiB |
| Standard | |
|---|---|
| Limited Slip | 51 |
| No Spin | 6 |
| Value | Count | Frequency (%) | |
| Standard | 2096 | 18.1% | |
| Limited Slip | 51 | 0.4% | |
| No Spin | 6 | 0.1% | |
| (Missing) | 9420 | 81.4% |
Length
| Max length | 12 |
|---|---|
| Mean length | 3.947291109 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 73.3% | |
| Uppercase_Letter | 3 | 20.0% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 93.3% | |
| Common | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 9420 |
| Missing (%) | 81.4% |
| Memory size | 90.5 KiB |
| Conventional | |
|---|---|
| Command Control | 57 |
| Four Wheel Standard | 1 |
| Value | Count | Frequency (%) | |
| Conventional | 2095 | 18.1% | |
| Command Control | 57 | 0.5% | |
| Four Wheel Standard | 1 | < 0.1% | |
| (Missing) | 9420 | 81.4% |
Length
| Max length | 19 |
|---|---|
| Mean length | 4.689708805 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 72.2% | |
| Uppercase_Letter | 4 | 22.2% | |
| Space_Separator | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Latin | 17 | 94.4% | |
| Common | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| SalesID | MachineID | ModelID | datasource | auctioneerID | YearMade | MachineHoursCurrentMeter | UsageBand | saledate | fiModelDesc | fiBaseModel | fiSecondaryDesc | fiModelSeries | fiModelDescriptor | ProductSize | fiProductClassDesc | state | ProductGroup | ProductGroupDesc | Drive_System | Enclosure | Forks | Pad_Type | Ride_Control | Stick | Transmission | Turbocharged | Blade_Extension | Blade_Width | Enclosure_Type | Engine_Horsepower | Hydraulics | Pushblock | Ripper | Scarifier | Tip_Control | Tire_Size | Coupler | Coupler_System | Grouser_Tracks | Hydraulics_Flow | Track_Type | Undercarriage_Pad_Width | Stick_Length | Thumb | Pattern_Changer | Grouser_Type | Backhoe_Mounting | Blade_Type | Travel_Controls | Differential_Type | Steering_Controls | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1222837 | 902859 | 1376 | 121 | 3 | 1000 | 0.0 | NaN | 1/5/2012 0:00 | 375L | 375 | NaN | NaN | L | Large / Medium | Hydraulic Excavator, Track - 66.0 to 90.0 Metric Tons | Kentucky | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 1 | 1222839 | 1048320 | 36526 | 121 | 3 | 2006 | 4412.0 | Medium | 1/5/2012 0:00 | TX300LC2 | TX300 | LC | 2 | NaN | Large / Medium | Hydraulic Excavator, Track - 28.0 to 33.0 Metric Tons | Connecticut | TEX | Track Excavators | NaN | EROPS w AC | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | Hydraulic | NaN | NaN | NaN | Steel | None or Unspecified | 12' 4" | None or Unspecified | Yes | Double | NaN | NaN | NaN | NaN | NaN |
| 2 | 1222841 | 999308 | 4587 | 121 | 3 | 2000 | 10127.0 | Medium | 1/5/2012 0:00 | 270LC | 270 | NaN | NaN | LC | Large / Medium | Hydraulic Excavator, Track - 24.0 to 28.0 Metric Tons | Connecticut | TEX | Track Excavators | NaN | EROPS w AC | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | 12' 4" | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 3 | 1222843 | 1062425 | 1954 | 121 | 3 | 1000 | 4682.0 | Low | 1/5/2012 0:00 | 892DLC | 892 | D | NaN | LC | Large / Medium | Hydraulic Excavator, Track - 28.0 to 33.0 Metric Tons | Connecticut | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 4 | 1222845 | 1032841 | 4701 | 121 | 3 | 2002 | 8150.0 | Medium | 1/4/2012 0:00 | 544H | 544 | H | NaN | NaN | NaN | Wheel Loader - 120.0 to 135.0 Horsepower | Florida | WL | Wheel Loader | NaN | EROPS w AC | None or Unspecified | NaN | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 Valve | NaN | NaN | NaN | NaN | 20.5 | Manual | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | Conventional |
| 5 | 1222847 | 530790 | 7019 | 121 | 3 | 2001 | 0.0 | NaN | 1/5/2012 0:00 | 246 | 246 | NaN | NaN | NaN | NaN | Skid Steer Loader - 1751.0 to 2201.0 Lb Operating Capacity | Florida | SSL | Skid Steer Loaders | NaN | OROPS | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | Manual | Yes | None or Unspecified | Standard | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 1222849 | 1040520 | 3854 | 121 | 3 | 1000 | 1529.0 | Low | 1/5/2012 0:00 | 966C | 966 | C | NaN | NaN | Medium | Wheel Loader - 150.0 to 175.0 Horsepower | Illinois | WL | Wheel Loader | NaN | EROPS | None or Unspecified | NaN | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 Valve | NaN | NaN | NaN | NaN | 23.5 | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | Conventional |
| 7 | 1222850 | 1061730 | 3854 | 121 | 3 | 1000 | 3998.0 | Low | 1/5/2012 0:00 | 966C | 966 | C | NaN | NaN | Medium | Wheel Loader - 150.0 to 175.0 Horsepower | Illinois | WL | Wheel Loader | NaN | EROPS | None or Unspecified | NaN | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 Valve | NaN | NaN | NaN | NaN | 23.5 | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | Conventional |
| 8 | 1222855 | 531393 | 23926 | 121 | 3 | 1000 | 8145.0 | Low | 1/4/2012 0:00 | 12HNA | 12 | H | NaN | NaN | NaN | Motorgrader - 130.0 to 145.0 Horsepower | Florida | MG | Motor Graders | No | OROPS | NaN | NaN | NaN | NaN | None or Unspecified | NaN | None or Unspecified | 14' | High Profile | No | Base + 1 Function | None or Unspecified | None or Unspecified | Yes | None or Unspecified | 17.5" | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 1222863 | 317287 | 4106 | 121 | 3 | 2002 | 3211.0 | Low | 1/5/2012 0:00 | D4G | D4 | G | NaN | NaN | NaN | Track Type Tractor, Dozer - 75.0 to 85.0 Horsepower | West Virginia | TTT | Track Type Tractors | NaN | OROPS | NaN | NaN | NaN | NaN | Hydrostatic | NaN | NaN | NaN | NaN | NaN | 2 Valve | NaN | None or Unspecified | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | None or Unspecified | PAT | None or Unspecified | NaN | NaN |
Last rows
| SalesID | MachineID | ModelID | datasource | auctioneerID | YearMade | MachineHoursCurrentMeter | UsageBand | saledate | fiModelDesc | fiBaseModel | fiSecondaryDesc | fiModelSeries | fiModelDescriptor | ProductSize | fiProductClassDesc | state | ProductGroup | ProductGroupDesc | Drive_System | Enclosure | Forks | Pad_Type | Ride_Control | Stick | Transmission | Turbocharged | Blade_Extension | Blade_Width | Enclosure_Type | Engine_Horsepower | Hydraulics | Pushblock | Ripper | Scarifier | Tip_Control | Tire_Size | Coupler | Coupler_System | Grouser_Tracks | Hydraulics_Flow | Track_Type | Undercarriage_Pad_Width | Stick_Length | Thumb | Pattern_Changer | Grouser_Type | Backhoe_Mounting | Blade_Type | Travel_Controls | Differential_Type | Steering_Controls | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11563 | 6333305 | 1800259 | 21437 | 149 | 1 | 2006 | NaN | NaN | 2/13/2012 0:00 | 35N | 35 | N | NaN | NaN | Mini | Hydraulic Excavator, Track - 3.0 to 4.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11564 | 6333314 | 1908162 | 21437 | 149 | 2 | 2006 | NaN | NaN | 1/28/2012 0:00 | 35N | 35 | N | NaN | NaN | Mini | Hydraulic Excavator, Track - 3.0 to 4.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11565 | 6333330 | 1879923 | 21446 | 149 | 2 | 2006 | NaN | NaN | 1/28/2012 0:00 | 55N2 | 55 | N | 2 | NaN | Mini | Hydraulic Excavator, Track - 5.0 to 6.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11566 | 6333339 | 1856845 | 21435 | 149 | 2 | 2005 | NaN | NaN | 1/28/2012 0:00 | 30NX | 30 | NX | NaN | NaN | Mini | Hydraulic Excavator, Track - 2.0 to 3.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11567 | 6333343 | 1799614 | 21435 | 149 | 1 | 2005 | NaN | NaN | 2/13/2012 0:00 | 30NX | 30 | NX | NaN | NaN | Mini | Hydraulic Excavator, Track - 2.0 to 3.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11568 | 6333344 | 1919201 | 21435 | 149 | 2 | 2005 | NaN | NaN | 3/7/2012 0:00 | 30NX | 30 | NX | NaN | NaN | Mini | Hydraulic Excavator, Track - 2.0 to 3.0 Metric Tons | Texas | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Standard | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11569 | 6333345 | 1882122 | 21436 | 149 | 2 | 2005 | NaN | NaN | 1/28/2012 0:00 | 30NX2 | 30 | NX | 2 | NaN | Mini | Hydraulic Excavator, Track - 3.0 to 4.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Steel | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11570 | 6333347 | 1944213 | 21435 | 149 | 2 | 2005 | NaN | NaN | 1/28/2012 0:00 | 30NX | 30 | NX | NaN | NaN | Mini | Hydraulic Excavator, Track - 2.0 to 3.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11571 | 6333348 | 1794518 | 21435 | 149 | 2 | 2006 | NaN | NaN | 3/7/2012 0:00 | 30NX | 30 | NX | NaN | NaN | Mini | Hydraulic Excavator, Track - 2.0 to 3.0 Metric Tons | Texas | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |
| 11572 | 6333349 | 1944743 | 21436 | 149 | 2 | 2006 | NaN | NaN | 1/28/2012 0:00 | 30NX2 | 30 | NX | 2 | NaN | Mini | Hydraulic Excavator, Track - 3.0 to 4.0 Metric Tons | Florida | TEX | Track Excavators | NaN | EROPS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Auxiliary | NaN | NaN | NaN | NaN | NaN | None or Unspecified | NaN | NaN | NaN | Rubber | None or Unspecified | None or Unspecified | None or Unspecified | None or Unspecified | Double | NaN | NaN | NaN | NaN | NaN |